The 窶廢vent窶 popup menu is used to choose the event type. An MS Excel 4 event supports the following event types:
窶「 Set data
窶「 Get data
窶「 Recalculate
窶「 Do script
Set data
The 窶彜et data窶 event is used to set the value of an MS Excel 4 spreadsheet cell during a simulation.
Get data
The 窶廨et data窶 event is used to get the value of an MS Excel 4 spreadsheet cell during a simulation.
Recalculate
When the 窶彝ecalculate窶 event is sent to MS Excel 4, all the currently open spreadsheet documents will be recalculated. No results are returned back to DynRisk.
Do script
The 窶廛o script窶 event is used together with the 窶彜cript窶 field. By entering scripts in Excel syntax into the 窶彜cript窶 field, you can have Excel executing these scripts during a simulation. If you know how to enter formulas into an Excel spreadsheet, you know how to write such scripts. If not, we refer to the Excel manuals for further information. In addition to this, there are a few things you need to be aware of when writing such scripts.
1) Do not begin scripts with an 窶=窶.
2) If you need to refer to a spreadsheet cell in your scripts, you must use the following form:
Worksheet1!R1C1
[Replace 窶弩orksheet1窶 by the name of the spreadsheet document, and R1C1 by a reference to the cell you want to refer to.]
3) If you want to include the input value of the event in a script, use the placeholder character 窶倪\ヲ窶. [Option-.] DynRisk will then replace the placeholder by the input value before passing the script over to Excel. You can use as many placeholders as you like in your scripts.
4) If you want the result value of the script (if there are one) to be passed on to the successors of the event, be sure to check the 窶廢xpect script reply窶 option checkbox. Otherwise the event will just pass on zero.